SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456683 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456683 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262404,645795,576514,542181,156528,197879,46710,959871,205962,629171,513163,994374,146427,259461,291629,669580,894243,132749,835235,71649,94287,375798,195721,676873,512180,154040,667432,649458,20677,876530,613970,258061,908253,271309,430387,564240,1039750,748033,593582,1007545,730325,369287,967139,589562,535288,463658,687085,462126,423424,295116,604190,589618,997149,425791,885844,925563,209636,483538,412542,811665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]