SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103403 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103403 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614228,382728,778817,552735,957062,226929,208463,485296,318619,854687,734372,294487,615257,20326,721113,243866,197106,454975,525107,878567,854852,540458,908072,81812,992997,687658,1015519,594503,986535,191207,931699,939758,407089,555075,577166,147648,199186,732905,198753,424841,145697,788466,525403,205408,801702,540178,733082,481667,817770,621426,256404,596357,1047877,859587,789465,872095,553024,811046,671111,215380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]