SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541303 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541303 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848041,501152,248606,948236,31108,339278,822157,605358,1031343,628258,549614,206423,195026,895136,593933,936186,421643,41197,491133,587600,791518,943965,464770,258496,930314,111489,483495,916688,783733,739473,923287,922575,511275,521806,547380,16837,23426,349618,514026,836641,409114,143300,534631,886257,885989,398745,86395,1013782,532091,599138,176110,876341,430968,54664,154994,290293,205446,445134,210542,93382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]