SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534148 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534148 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45159,1028651,727646,312977,195048,861397,700579,354075,29638,262237,22511,613014,1029623,719556,576847,556123,689769,466119,668877,1034436,49416,927394,620921,771615,825739,761237,258396,471654,763839,959170,280331,219834,126504,998949,374667,973654,479453,677224,1037364,1025435,485840,99753,1035135,671192,712260,874899,1033505,905541,22430,363327,789778,993223,843236,302587,623725,786616,459681,414394,105423,6022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001157s ]