SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005666s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016616 LIMIT 1 [ RunTime:0.003110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016616 [ RunTime:0.009309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507008,303084,552621,312229,431681,624607,5178,260932,304818,178965,717815,36076,259943,307970,163411,419075,532828,818733,1024927,620003,339766,1000959,878582,534762,252911,372412,283225,48917,215062,834469,507339,547588,1015068,329625,398547,291364,293446,259999,257752,657885,952170,289066,688508,404194,693828,374707,248437,308815,439858,69325,332793,610934,1043192,20421,519972,401815,69226,1040974,293169,886263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003106s ]