SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030067 LIMIT 1 [ RunTime:0.001269s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030067 [ RunTime:0.005176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267531,75013,557418,877473,234064,10077,669589,520609,169944,716770,555248,218459,87762,663100,129150,609591,780386,352863,1005455,647899,422244,921353,152996,951437,770817,293237,859723,1029293,769573,930100,544734,1027928,829376,437541,715481,715520,795374,1009853,122181,93067,273825,442583,1046452,118052,950759,480825,93808,953110,628142,441398,47267,319300,675698,675677,1009577,88563,40059,939726,233474,606241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000890s ]