SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028189 LIMIT 1 [ RunTime:0.001513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028189 [ RunTime:0.002972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768214,171589,8115,489305,640244,306568,522549,670533,592748,284415,772279,796543,941038,103209,358314,218520,914950,231752,502317,652955,618854,488468,928382,408667,522555,462513,878210,877624,17319,698808,993322,274881,1028111,224280,827665,445850,546538,153796,813016,128141,493656,896788,42989,880615,933591,304397,166191,76051,142603,75643,242539,558609,473169,636869,457369,851470,14117,797630,374675,888621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000891s ]