SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045906 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045906 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674639,42782,149071,612216,1042283,746311,153101,256954,135897,983764,174968,487394,747460,898372,940212,672797,332430,472743,283601,445956,1027925,508362,561385,185237,788097,836483,48031,58128,121672,753227,483361,151972,431683,658398,190242,718787,866159,86636,388615,751175,48545,407834,984159,23349,1033518,995424,978658,166562,339207,425508,292883,911763,303598,126734,211905,729675,352955,222118,214100,733460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]