SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438900 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438900 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364382,365184,370691,427354,434055,95253,731317,512406,277489,205697,433528,922482,307322,847517,1029444,800600,927497,38762,397907,69765,347216,97481,210404,537170,188559,139306,640637,131022,99669,28136,770810,243795,282782,796640,755020,725550,84502,987492,707316,418250,107869,697205,451478,659139,1044897,123342,840550,427722,748541,519613,1040810,731339,894777,907974,516963,335040,43,343154,1031819,576521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]