SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528936 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528936 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896940,212292,145549,958747,840160,946151,13759,927872,140164,891528,482646,40093,444246,662783,860078,777255,617963,336370,841905,493273,7049,395803,573452,3561,877625,161628,79454,189496,270898,837385,1022714,700543,648443,577670,496373,1013577,270686,479376,555803,635922,757632,735359,737451,717730,532034,994415,658792,851121,199269,725763,835646,297091,155662,620915,218305,452565,788898,34271,848072,516538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]