SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405531 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405531 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333195,110750,406705,700038,606907,609693,275138,714434,959028,531317,894064,743028,787924,493280,610055,178982,821251,494607,454834,54353,746530,498479,818686,276900,784972,12992,292815,274025,551900,369700,682219,403161,119093,425671,837437,894297,546778,175789,528626,124987,835309,58540,958671,566334,230714,731023,183332,566572,888683,1015649,667254,904371,595698,274987,674252,231068,41012,58952,578363,299904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]