SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520704 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520704 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302597,1016440,48274,856017,795591,775858,429859,31568,859555,954780,642221,789865,621813,565396,663074,47922,499136,927323,439812,401313,356700,412301,836900,41782,463872,326732,345110,360257,5735,1003934,226943,774471,684333,304344,765128,1031376,610435,641380,338346,100452,239,573102,578641,729795,193035,991122,295186,145438,13304,794966,778331,335807,591895,491867,982537,173452,386760,572653,292315,194726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]