SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457475 LIMIT 1 [ RunTime:0.001265s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457475 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947710,502923,1047312,859203,353884,686219,858688,579565,140125,779522,897289,134054,624154,193881,1029647,839497,745001,825129,600393,675130,537291,1019534,609139,64118,1012078,552909,424652,326095,598637,221318,219653,303825,172601,168088,959395,497309,144604,894370,934916,927538,260897,193790,310884,194128,794483,658457,889383,394466,397680,823036,156621,71092,79301,199198,333987,45654,579526,475055,670680,491561) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]