SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 745043 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 745043 [ RunTime:0.005649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52326,418442,281783,12287,701701,215644,571115,19764,732417,995278,921134,385480,815424,569484,9626,236188,812605,175268,220779,988755,978924,592574,3919,483056,744062,553986,353374,784862,149587,723096,547054,544284,816280,929380,652454,823225,193950,1004042,872641,35493,164690,985026,905209,118529,779696,496928,507861,601185,940533,434820,253287,919841,813962,1014554,660959,440049,738613,290336,324890,845087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 745043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 745043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]