SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439064 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439064 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890462,145835,989394,678378,522493,185358,1018319,691140,908158,113838,693605,808577,355315,162073,704489,404316,998139,991080,94338,594138,572912,10452,100614,382909,370413,764799,5565,873067,212157,99801,892754,220643,821552,461430,316504,583963,242235,36814,116630,447349,644491,719308,228457,294440,490827,643042,566057,233279,278607,480489,644489,692317,515992,207855,71332,125829,757582,173207,243369,722450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]