SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003581s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280474 LIMIT 1 [ RunTime:0.002419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280474 [ RunTime:0.003398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419987,999893,194705,145460,1010890,748938,994879,391098,122797,470455,931679,294609,820530,627841,59612,18769,792004,880344,413423,89799,69345,346034,922957,742728,968997,542183,335336,906004,171633,590231,404111,493596,811433,34920,85828,954904,617888,505132,643535,981876,1045426,428652,592778,326240,829107,683042,111967,844835,36703,509004,163324,207485,449441,664022,557452,3053,755839,148219,758168,621115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002246s ]