SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295581 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295581 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368215,442196,963515,80333,674047,549953,946497,403893,113390,300053,380943,405531,545873,563476,641452,833293,10324,437672,706299,573513,530713,932871,296199,282647,805928,672375,1040568,706966,704977,865729,658162,415260,853867,150203,49941,488667,224003,205936,616904,81752,562657,482614,176640,508191,867673,795179,340119,107541,645242,674690,656922,459318,515612,574824,296933,326137,367025,421265,552458,37331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]