SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522896 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522896 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573531,581858,91059,1004696,692285,491780,618538,479926,794822,247068,462537,999625,1011426,864281,574386,599535,182134,970818,703794,210157,1019303,396759,692813,164422,737769,62331,671201,587306,516593,1006841,6021,735945,283231,319670,450064,149338,103748,609005,226715,104721,290641,1038194,1027860,705873,173928,660678,553757,821028,171885,310237,432734,111789,1023462,1009630,715478,179445,560301,106989,51745,242567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]