SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264839 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264839 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527215,410517,481456,930882,304907,874661,48601,1037220,293050,331413,1042941,302908,231780,86446,260166,936320,758273,127489,888388,215026,1040911,861376,520503,907466,841532,622082,748954,270673,251921,640540,963697,143317,67496,146578,664314,1035441,786738,922365,430237,1003081,422636,95863,758429,641775,484064,314623,966164,985862,1023451,259714,560837,516170,902670,33138,242288,887093,586497,857130,897239,131479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]