SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038525 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038525 [ RunTime:0.003129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849251,203646,283890,422098,117698,144347,897840,505029,482476,616346,175358,246408,912585,623631,490232,216407,943167,46395,131,10621,1044004,849966,398691,969699,131017,925083,898418,928501,168294,767905,256864,830645,672708,493038,928273,478475,83866,559186,625071,589605,497285,504931,1031119,472467,186648,924342,685211,585799,401200,106238,802041,713710,958163,173041,864828,172990,457554,869554,609126,432204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]