SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381098 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381098 [ RunTime:0.002486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242589,692362,417855,175727,279541,446931,669559,982480,749722,350635,606495,25217,668316,87595,43223,907085,361649,595345,830948,761235,858086,633679,832885,185730,692341,723646,368935,1035043,671797,572053,598952,73968,257126,1004990,106181,21312,1016495,342354,553471,635713,917835,180592,308489,962294,408815,225955,1003647,828837,518192,290673,544026,45573,900295,809893,611341,773438,984409,161436,535894,649513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]