SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104073 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104073 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938032,21908,311421,925316,407808,323061,702400,280294,43875,989248,294934,614118,495446,746359,254136,237205,78867,471633,372030,259961,380971,1002510,107027,535298,746712,779991,390480,279968,264499,398987,641269,678206,754273,911353,508955,253191,712243,38882,135762,663109,502822,278633,520378,880678,561263,478766,723791,536494,829632,761668,752098,911141,542244,532124,874341,685560,183826,561872,286173,979075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]