SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536273 LIMIT 1 [ RunTime:0.001203s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536273 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807152,341485,518013,197276,1034102,561576,662251,202220,1042635,67563,803758,471673,326502,928014,871140,740230,469141,767176,965479,211647,745662,898071,828262,486639,640317,712051,438728,55499,682862,1012559,612803,1031863,860414,699680,830673,500959,656252,82673,207768,224946,139504,65276,445134,444667,315080,1002282,439067,521850,87991,556991,388885,791661,86368,212547,128056,844372,239590,930953,356166,346325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]