SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114683 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114683 [ RunTime:0.003256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199335,908778,418971,867039,863765,757186,307660,820219,694480,761042,160021,118061,636445,244185,49802,828573,663141,678380,556525,242336,920031,1047418,997857,149971,645793,326111,893916,1019441,104312,241023,674345,705134,871801,318564,855533,749604,9240,305120,290974,44533,360789,523937,514399,467288,200352,569168,191506,521788,716524,178583,733629,386522,688232,438745,204456,351942,81000,71446,738725,905084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]