SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445659 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445659 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963880,1012715,1013045,1015387,121409,1016836,19136,253048,560581,470409,939959,510844,264198,412380,471795,109688,16500,438341,1013774,1035564,407923,1042004,678460,881012,760593,339802,447751,787778,11829,209209,446952,372605,930019,709017,128009,298356,946794,252810,11539,542272,741564,1044442,851336,419952,347382,626207,210037,17940,296014,203914,843637,321165,996022,551473,505456,297853,93506,928135,798149,322468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445659 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445659 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]