SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001952s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022683 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022683 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404818,560765,161798,206228,1019283,475980,443047,595504,993180,1010598,278179,1012990,110641,722006,342547,357140,624757,382683,961221,565436,76800,275060,321680,897129,102020,458580,890473,107434,73462,464038,950280,367799,440370,747392,674530,717751,759504,161119,582980,806576,326463,989906,366318,120536,910325,217331,904435,143854,68111,852284,823425,848124,317553,303432,398835,892897,688926,645053,633577,253464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002639s ]