SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005711s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253106 LIMIT 1 [ RunTime:0.003341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253106 [ RunTime:0.005874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47002,421264,996895,315682,127761,778263,980968,546988,853927,67927,694203,935429,228331,153912,54041,956697,217366,653235,26023,703456,80500,23088,310018,625341,102161,867151,604271,231693,348295,79950,977485,140381,1006373,46536,1029680,896378,345344,445194,658563,711520,679411,504918,617522,678159,575720,433159,905376,107299,913681,832967,936374,1019965,885471,344586,17368,10789,522482,966541,572672,244315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]