SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437713 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437713 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212292,829500,219333,754946,48246,860449,337484,517374,541791,502828,388224,255620,1023678,39893,50517,81175,258017,874936,339208,607829,381007,713310,523464,119394,443309,485675,126602,823801,971123,188190,478892,834368,5355,817577,966558,959205,282516,242103,715152,637264,204540,234582,464266,677530,541738,840833,464153,915945,770911,922244,476732,1002671,937586,581399,604679,188596,468949,139964,156350,59460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]