SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019356 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019356 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531659,256025,356946,358859,896930,235630,297110,555885,993750,386167,170948,140912,63848,238360,364443,263811,804143,974168,197974,326175,536590,381705,301960,826114,635182,548817,135500,563060,870001,1019173,936385,142607,416569,255409,933212,763087,490608,216220,1043167,916106,282517,286928,163952,212717,741580,553890,633936,443592,246224,940463,992057,676872,607771,1452,277653,332073,951667,1041568,479575,946465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019356 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019356 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]