SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502471 LIMIT 1 [ RunTime:0.000795s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502471 [ RunTime:0.003593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032378,80137,184168,600583,62751,774776,516654,896776,770809,17220,293658,645209,955910,384068,523629,89430,14201,910059,847820,737336,930153,849318,26149,973734,936434,420645,898217,260589,923505,849272,543789,772528,3337,851847,184124,366887,712524,670704,816737,258006,287707,201910,516737,957600,174373,376046,1005219,422970,425802,27123,456809,721425,341519,995537,58502,22962,726488,669579,493522,124585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003569s ]