SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449024 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449024 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947151,468303,587995,562839,488706,390663,308381,918578,519521,530186,525756,205463,114138,485424,267811,391992,828767,433570,576348,527895,1016541,405942,143815,315219,694756,378965,744015,872049,527461,542311,236684,606718,313138,135021,254012,326897,1008861,894706,875411,23177,1004759,624097,589496,26235,714830,716197,985929,155042,908048,941465,497568,159645,96969,349441,369223,205550,947603,817936,574440,184144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]