SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533961 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533961 [ RunTime:0.003506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179067,342358,879810,845988,613008,823784,778121,253286,511299,848870,939698,28844,891257,782590,292699,706755,893929,655420,481823,231117,466683,511817,437033,423333,454492,226546,422255,854011,985425,832612,544843,186879,478522,1017537,661440,823673,99586,641075,32556,810852,122582,1032456,905698,966916,195257,458300,292782,282113,663978,786313,768654,851273,852509,611237,359735,140510,355880,755538,577908,93371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]