SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517178 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517178 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374146,978439,339044,418331,739092,337974,640775,918406,985040,482712,1025150,518348,474845,805896,1022151,985277,236667,215288,120029,236927,137304,999913,380666,244859,460501,271836,364712,772054,540961,807035,87769,98170,918807,751782,395200,709061,69574,72151,438430,307470,361757,686960,269602,896326,387129,681854,446167,161580,566249,482037,186894,956144,430811,845150,61166,329521,115423,963449,550133,577617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]