SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100043 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100043 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039949,308649,672579,914335,505475,202585,517039,777724,900311,72859,589149,386063,18091,238293,453894,297905,1048462,849875,471588,355898,410814,844683,568763,606677,346559,444688,902304,931547,249156,979099,633586,493959,908434,406538,814188,619667,273056,547071,616713,447300,447745,702524,363750,743862,744371,309446,313157,613880,200884,256480,993927,408287,1000973,587781,1044061,523848,118924,786408,830588,698871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]