SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019494 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019494 [ RunTime:0.008425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194424,658482,8058,493038,121573,558131,409486,634620,51212,939555,205551,1047099,709495,971651,393916,597612,469715,636290,872114,111956,136891,851250,994222,920658,810884,590889,213661,300721,427388,220704,381138,550763,603548,884752,1042050,496213,887858,914870,325929,1009513,209641,88511,707109,305017,382426,229325,345861,599976,858944,876203,543473,516878,392514,552219,926028,33333,998466,761110,763431,1038355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]