SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498403 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498403 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707081,1042349,878380,699834,982900,551291,973075,479521,743461,434805,287502,340250,820795,709116,683399,1031104,813434,979964,353120,503688,782186,335995,340401,100964,561050,377260,452026,271563,956106,424028,706440,679304,104818,893031,581992,885505,631777,63027,931085,910421,21154,125409,658778,936007,849604,231027,47547,934215,463675,834257,132971,966392,989106,112390,855814,1044738,890941,132712,215305,58286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]