SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003740s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291470 LIMIT 1 [ RunTime:0.001007s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291470 [ RunTime:0.003553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251248,931987,296688,425884,240740,42936,469196,568616,470733,299848,1035931,198861,487197,655487,515826,259440,626335,887682,260080,438123,1038108,419897,192235,581900,299839,668380,952803,832704,779903,57464,14475,967903,1020806,342841,507296,97787,1036499,692633,139211,405145,246983,1015053,950851,207955,749059,561308,906093,541583,432305,911408,452233,555050,880603,489462,811400,202446,892433,977521,770636,962683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001757s ]