SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421899 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421899 [ RunTime:0.003265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109190,727944,951284,920613,993577,639844,560162,283265,701946,196116,442670,732386,824056,1040476,533041,312074,877308,875562,690842,270240,91852,350877,795884,758395,50603,996419,334123,16662,181244,928417,43598,993846,74269,131241,529183,417164,569952,969943,163874,942346,249049,711294,853700,367134,309916,569677,923509,362928,554864,56484,318593,733351,722183,863271,738404,426709,345169,482098,572236,251529) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001573s ]