SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331741 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331741 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586067,345029,751943,469137,52247,531874,635811,721901,621787,250273,584822,75877,955164,762996,1457,825329,900787,279059,1048680,886472,1032952,6932,867647,867472,544739,499857,293726,632117,330443,733383,532364,262849,238714,1035527,577199,931011,693259,670881,3759,372433,647367,185833,964379,945715,315945,845237,336462,27001,543594,316130,690349,569429,169326,435720,1039119,356092,892731,802352,537083,950075) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004140s ]