SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 251218 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 251218 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342667,263469,907106,106004,460819,632644,203512,785610,881702,1021189,217052,866208,259601,429120,840188,221493,273478,471996,904174,172774,530844,147602,630065,801831,1042797,377432,341874,1038813,563448,1028200,738450,824532,774701,209404,124701,879423,157686,97276,945297,55947,388819,970959,3534,380577,773274,213065,331767,988841,851889,407759,617,867641,479355,1006637,1038055,464331,820052,878638,462654,252269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 251218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 251218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]