SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017457 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017457 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694582,552074,644769,789737,350930,648567,741316,846749,329820,254725,126977,383238,403342,609017,111776,749495,435338,244235,62309,541045,83437,544546,864677,240710,769223,299430,272391,1007501,115950,458613,158500,951752,317855,407401,334774,1036181,18406,693396,996274,11279,116525,163881,683216,817122,94774,699147,633434,336286,985395,433992,926247,988251,66615,228505,934640,187736,464578,141385,287235,516094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]