SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 187491 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 187491 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599087,360431,946639,17667,449764,489399,986695,1033141,309460,834592,637674,303005,880378,82987,610132,352533,592877,714372,271994,17540,476564,319829,450695,449396,799530,1034295,210297,17599,540911,126587,748692,192740,956464,901323,952210,12125,542449,210716,682779,275177,190896,303274,561932,424750,91585,488425,614880,106551,743522,703965,761736,706857,637191,616321,634563,865023,887571,794455,97657,431694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 187491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 187491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]