SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014490 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014490 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431227,573413,148971,12566,748435,162606,688607,588009,772026,982358,454545,710507,1030562,183432,1046957,392518,939231,68866,965878,261786,683000,82915,748081,78436,905317,425078,508142,704899,632654,448675,274884,628338,1045021,1040676,282160,746404,761969,340788,1007981,499301,630682,496440,271129,291826,670363,178226,601895,235236,279907,547357,720112,442095,672189,336724,251268,739782,920792,766129,617841,979970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]