SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19864 LIMIT 1 [ RunTime:0.000826s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19864 [ RunTime:0.002778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447274,97022,556133,155170,325308,519232,160981,551760,435528,214581,730556,797926,488865,537762,405347,148563,834112,490213,840672,686354,664146,831691,440134,218952,202632,212537,399609,312712,515567,555889,904949,173421,754731,902333,199804,912778,644899,336571,773008,952534,296918,439523,442146,146746,934088,942910,79786,173122,241617,875495,781321,1048387,127358,881798,943702,434685,809199,628910,101807,835132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003176s ]