SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684942 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684942 [ RunTime:0.002595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19311,865458,1033714,840812,403398,738373,29191,256730,468270,849762,706176,592450,733540,405185,558841,208472,65147,418532,610105,46865,280053,859964,162388,103934,901872,23068,109371,921787,317995,827464,342410,779915,63032,659432,656917,336978,818980,170139,861847,187413,332519,676828,803875,187785,643637,11204,333708,588596,991341,644446,489947,250568,338229,776642,73217,399537,340161,26496,350901,493028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]