SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517504 LIMIT 1 [ RunTime:0.000985s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517504 [ RunTime:0.003156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223973,307579,3201,761642,439241,379538,432400,778235,832869,373035,750731,904678,99512,422444,324351,1003162,133614,494274,441023,323849,637026,94414,735006,128019,646094,492904,606648,804716,248720,1019882,457806,934851,1021784,676367,660558,818932,648567,227410,127592,818063,636779,488682,130860,807501,951303,427197,315443,185143,520101,836280,552338,270360,264163,406608,375237,380507,660880,1025163,884998,769326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]