SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423491 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423491 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182825,152850,110043,274068,637107,744018,771507,686890,320529,711632,300312,43787,3415,848989,670602,260136,923264,158089,675278,915130,487857,662892,757015,494579,883525,1028409,177781,754471,896786,743682,622419,862739,618184,179557,354668,126778,190340,656544,19206,119603,176576,937790,361410,610736,740870,648777,321263,476855,626676,858060,295759,302535,999320,1044446,98047,982153,955109,314419,486149,671672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000882s ]