SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001907s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037481 LIMIT 1 [ RunTime:0.001607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037481 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446310,17487,891737,827858,648438,868802,746057,653405,930692,925544,583875,875462,785676,123113,387999,809032,91761,889086,498350,834158,748209,615184,941999,202381,768043,427216,466072,72457,515468,382757,498401,762388,506333,43505,334041,731930,801939,369441,254806,701062,1027602,632997,162007,381269,945709,32404,563369,590850,684588,430507,944771,122409,520773,779044,583493,829278,257367,630594,143522,272387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]