SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002921s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281473 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281473 [ RunTime:0.005366s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162063,193321,561353,740430,65727,373539,982014,1001799,453886,719274,384066,344829,355155,1040063,573257,871090,211500,777287,341941,267075,310729,462240,252531,696592,35714,592867,187652,523742,114199,417542,623923,583954,89536,225939,382370,988201,1012937,1034075,74474,341276,740479,176976,86455,105276,312823,181754,418022,994506,128608,165928,138408,378170,67246,228083,1039071,249006,335455,488671,1001195,342445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]