SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 789610 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 789610 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655049,282524,436624,240216,876801,1003815,826633,963117,495989,331136,801310,723838,858565,714033,400574,214592,1007966,358405,26472,795846,777322,24546,434768,916808,937226,211088,977945,394653,59484,904503,972024,292550,199845,774832,944032,380418,250868,766531,174411,8424,608394,910309,1001026,798397,106722,794767,456236,27772,946938,674290,642471,1010695,409700,629139,856225,602697,304436,203005,866111,558168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 789610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 789610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001319s ]