SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006874s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033452 LIMIT 1 [ RunTime:0.000634s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033452 [ RunTime:0.002858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819274,723559,695813,440256,143005,557193,997515,174384,415649,845016,352020,696259,341899,748580,650063,739598,524782,787923,768300,820042,465471,193104,802105,624365,869842,285333,822452,385481,570965,857300,1031089,843048,63720,1012419,620503,545422,885353,897219,468433,344895,547003,486500,316486,423404,762380,703386,714288,498451,515725,783680,887543,491052,236648,395589,737205,351790,277988,925448,766317,665398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]