SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 309094 LIMIT 1 [ RunTime:0.000756s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 309094 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029842,472517,10192,209219,196298,897320,40896,1028160,348628,658155,782517,294046,404932,400475,299307,6243,983152,240218,158357,776429,884261,453595,623824,856337,1008404,501135,148136,638189,526923,375323,47725,28202,510634,247694,501827,587089,215806,446341,279647,272260,1007596,115850,621362,472651,880590,1003178,180681,714193,56967,233033,994527,816564,149264,136333,428442,291310,810930,87818,391071,563448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 309094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 309094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]