SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100518 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100518 [ RunTime:0.005420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735478,228867,271911,337869,377623,533880,907968,132844,14078,113174,355983,602176,1039168,757151,543284,432220,804924,743806,975628,456294,464106,188094,690144,332100,633434,723190,324241,268572,923217,851528,654705,283674,570842,1012186,491631,670418,769652,631975,818013,860066,948838,114972,249024,749907,699767,430352,911197,861427,964983,900226,208195,888706,623627,105955,852029,960005,273065,464293,569743,95302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]