SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041398 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041398 [ RunTime:0.003711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423070,844991,438652,47524,1033317,646811,535618,513291,241254,585021,465480,84154,905141,263447,781035,308669,674623,432751,194041,83129,439019,382383,732689,284921,550406,892172,971268,155430,361855,197148,312105,798367,876569,393217,632804,927523,62188,1048246,170048,418982,66995,167423,649193,538916,964181,540487,562077,584569,968957,39083,863101,414996,980430,1027858,850777,384569,324980,415399,515731,711310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000698s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]