SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038503 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038503 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124048,521794,386228,333874,520242,185763,906031,92900,631330,551882,480949,618347,494159,994827,772452,571864,284904,21409,674354,282898,704828,465325,135337,955891,980565,425342,653251,228785,771915,817241,800923,19727,353631,725487,1024824,37964,559068,151,482535,635101,390949,829215,158987,168905,974042,368482,291082,672641,172191,85769,951444,397610,764995,678549,207973,478240,702847,942170,654601,858145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000832s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]