SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553940 LIMIT 1 [ RunTime:0.001104s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553940 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942709,367262,826545,398057,720830,369299,733492,140627,823463,725378,366679,725406,680611,243161,970758,807482,120208,667832,19139,472079,332324,404705,687063,323245,624350,645509,978947,139726,387118,353726,459494,225786,27324,917530,978458,689996,78520,803439,217243,790443,233808,299168,48861,57407,856928,1026837,931651,969120,541476,892338,448851,848762,170065,363904,425164,902564,795784,630801,70427,206011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]