SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040424 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040424 [ RunTime:0.003349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470263,668237,746197,1011111,242683,802840,305572,736849,402067,136187,103181,452141,178701,817899,968010,695699,697381,181847,861625,416191,884667,490892,982915,304950,224076,244037,975021,562096,864093,183886,461698,343087,410404,678914,776982,965423,626462,980990,454522,387789,300791,603741,590700,899408,458749,533638,877619,887184,687417,844348,680602,230169,611874,869097,229094,315038,340645,783762,500551,695186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000873s ]