SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261830 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261830 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555524,421446,1003749,252061,579356,159800,984932,915487,484078,654337,565523,445936,1008331,708078,813458,72645,375226,1019488,96286,389233,109201,235212,667266,524418,640993,550425,67855,442564,741467,338679,58798,738280,690468,547943,377103,953934,19134,287225,837325,458270,652102,805572,781847,165494,386780,1017649,223798,351293,290485,667664,947430,926960,215799,540143,927583,774249,193407,438580,393074,257390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003009s ]