SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26113 LIMIT 1 [ RunTime:0.000800s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26113 [ RunTime:0.003990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217728,908149,273813,672807,140316,345752,22525,147924,366966,685358,850110,190360,982702,675996,622897,202884,881535,237814,853416,904024,566368,412708,759708,881210,511132,511258,360342,217969,856852,121914,442482,804475,249138,264727,826297,268886,665647,368044,653098,669128,753001,327849,705080,961324,669168,1037632,480940,312137,146884,300764,761958,167392,80681,953110,189283,440631,785817,834660,36605,1004609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]