SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801949 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801949 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799484,108760,1041515,85490,520998,939771,314534,413322,689657,290370,190803,137974,330370,867083,662808,659352,1006242,952948,637678,672798,333526,333074,756678,786081,960970,917090,418113,251895,977274,432090,22566,25804,744904,32359,708512,509206,186957,697295,393419,140723,484724,444744,487332,17528,635623,37008,835907,177065,1014914,8855,776741,244730,960535,155090,975454,994299,451086,313089,688138,922264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]