SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437412 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437412 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204242,888066,340474,13182,855758,26348,847574,460236,807016,360139,501816,983263,566930,96965,305343,412192,490045,608263,261956,689840,909612,1011244,50300,822613,841880,572954,209328,947663,692441,206384,465209,567144,831746,85195,499216,556959,504753,907913,1020878,833312,641475,694657,469198,311913,934118,458933,683338,160362,893952,519429,331014,528768,421551,1030759,230489,2013,152202,607874,707008,145163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]