SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031343 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031343 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431104,1045135,412973,243270,72653,604495,83435,612519,273022,752110,915807,180955,1001422,127849,517680,179319,154464,926553,167423,579679,934268,740050,459619,301804,896463,645931,1036282,136797,291069,517342,775894,367843,975372,182261,414022,1044546,615445,635780,478376,983050,697114,136700,686570,1037098,103192,913361,733898,315064,364615,885418,605313,887493,230041,229172,366501,713018,784354,270777,389534,354895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]