SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458491 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458491 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540662,1026110,997086,703441,821704,565836,533225,355312,60337,201985,795125,200893,73238,569368,703621,168493,639195,431221,735214,631380,25988,183119,627539,324537,482974,301863,877598,356069,231519,265932,906619,710380,986032,51500,685543,540963,669440,239997,451161,752804,825248,895,238756,733450,1012015,277442,173842,330173,831634,305663,167793,14042,726034,432729,354979,985654,294689,267499,260438,928650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]