SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457217 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457217 [ RunTime:0.003259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690834,1046796,669680,668630,412098,944392,246596,948095,77240,295489,313445,50461,127609,15445,701723,359918,447178,584398,698823,831503,382774,767733,625769,375466,1003527,771512,770116,111996,944556,822434,820239,109885,332758,955300,455673,1027323,345568,590823,873292,1028349,478218,249049,53141,600517,579261,407148,675578,845550,276520,497574,578175,315176,53211,388749,921665,913157,169421,614376,695744,798768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]