SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014111 LIMIT 1 [ RunTime:0.010567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014111 [ RunTime:0.010301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39191,229414,787539,520144,1004653,961358,150181,492250,999394,514358,430554,389977,346277,163441,829429,108529,497555,192648,855609,337890,419505,978956,95473,281174,622914,143076,46354,784511,643609,656374,533889,140578,272013,115110,230821,517911,98363,118842,521807,478937,832989,395504,954292,473337,227005,469046,843357,928111,544052,755333,195827,384732,497444,275482,263288,722455,65594,403051,802447,913160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]