SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030029 LIMIT 1 [ RunTime:0.005365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030029 [ RunTime:0.002372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122973,116337,660065,52877,521663,785800,549797,22923,16092,698987,208366,184832,538075,936742,457867,161357,278190,672814,210657,762078,938303,741445,429799,867278,676585,997903,428191,791532,485978,933406,692527,166314,734940,57700,413013,215851,676112,123370,59499,324528,408302,9689,829205,743741,424325,622975,427224,557176,351952,332840,520157,938249,663338,753547,624008,757929,636643,686413,358867,1038911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006046s ]