SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104802 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104802 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443780,701464,462198,413950,929121,627350,75740,369371,802076,86047,632975,873393,432129,770398,724339,938042,132360,1008787,140990,996647,895989,688890,978235,874585,969201,57811,337117,984133,381985,1042660,278334,805195,956466,181406,144627,895807,114733,416345,99156,553516,283549,712178,412438,280568,10549,790141,896319,348287,467009,666616,788321,1036986,340680,922997,662743,677031,516232,12070,965079,21709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]