SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102064 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102064 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529834,948698,282668,740261,217585,355700,16544,562319,124033,12939,375160,188693,805974,327679,147527,294238,292538,460007,921359,258195,709976,372189,932218,115972,506077,430024,633124,759671,42491,808586,798497,883046,666409,199539,854268,794759,961195,414764,308215,352554,341670,524870,243985,600966,310210,433244,349718,400875,658811,887160,870865,1025328,840695,355964,325371,97284,621184,606467,877113,1028853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]