SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356840 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356840 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426366,137523,129699,480568,25253,381752,292139,106575,768007,671266,185812,868099,414374,377535,721086,134757,338479,196605,395966,793067,545938,332817,374464,29063,470372,843026,259684,364385,867643,315697,135471,925899,129316,230670,731552,785791,70997,446467,261416,950148,952964,837745,277416,1027739,616584,467812,67573,198342,963816,489041,469844,905423,907625,765591,619591,505637,487311,579529,836226,831398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]