SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412516 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412516 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397700,701767,515239,774978,48913,880024,429886,99181,312447,669688,1026808,673123,821993,127757,738361,407195,125192,516908,214793,166549,841824,417891,470092,1000116,790443,860489,763593,277980,861594,530714,486648,651606,539516,498631,879520,460478,871557,866162,816399,1033744,1013019,873971,630849,279979,930228,314541,544328,227664,794531,737068,585802,73570,885478,205271,1014102,749083,604120,30096,221092,271204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]