SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424871 LIMIT 1 [ RunTime:0.000746s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424871 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693679,698786,607410,648290,943770,341384,131731,682508,854785,156112,549020,705753,692338,734519,513362,52220,645484,458037,278797,217754,1025734,439618,402887,42794,842591,733322,633908,187965,680217,199128,290949,78709,234797,726218,817181,117047,636066,258452,778559,85548,690013,863098,757195,813118,755892,957513,235622,1036250,844770,443971,351356,139818,753423,416755,1006618,857504,867270,54543,299867,769060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]