SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028642 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028642 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011548,977658,255955,126058,88706,394446,52538,886869,894576,812342,294290,89476,1003679,943653,750114,404555,1007839,675754,477423,417051,474392,41157,482277,493926,314460,1000287,575708,764293,706308,800991,432540,614555,339711,657903,366064,961993,533612,158968,770387,830614,1007737,455953,557354,126869,839451,803546,285352,1043921,785956,263354,656771,912360,348061,1044659,879021,98140,484159,923043,228181,8894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]