SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283611 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283611 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333796,116642,119454,227591,971040,246423,197979,337771,48909,2350,820265,980614,790434,774925,558191,228654,581273,329436,492034,830783,47140,562595,290773,213778,554158,230583,882800,285769,904934,37569,136097,830567,667686,318470,815475,264252,531395,434374,38723,937426,679623,969642,345786,326331,153138,971526,613413,700746,1002265,155603,878677,3143,992413,63983,583992,566911,502391,898375,711269,763836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]