SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028921 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028921 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315109,53323,866368,996573,94454,274700,926881,201623,113930,123423,246120,1020356,997281,819259,42196,77595,188453,772168,984436,255377,714281,874458,755977,1002325,719597,124170,291423,470233,266567,134942,316540,110981,126195,543388,245897,918714,558325,264161,867828,590221,590378,590377,545888,100382,57457,162240,995821,513584,21941,310866,750941,717563,281010,377650,504936,399259,622289,766126,984216,963208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]