SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511046 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511046 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200526,543771,497011,479680,682399,155016,421929,505886,996561,425860,575111,301079,709930,1735,67766,693500,937050,828741,251652,462485,240447,603155,743011,606044,690375,89392,482151,815322,192456,207105,747289,655259,937862,575821,803338,566882,427653,155916,848793,753714,260554,361543,345348,800241,732369,484449,932443,203628,476957,747002,793188,112383,343939,719351,906885,548435,459050,848489,600557,807819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]