SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002692s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 234511 LIMIT 1 [ RunTime:0.002466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 234511 [ RunTime:0.006133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52943,888228,974484,761581,202546,989392,154381,644041,949240,371606,488752,311873,799043,869612,679019,429102,1013301,247418,533358,835956,447116,762796,599364,974309,916,987016,197257,285866,135504,740012,674536,691244,19548,1042507,880552,1031681,958624,193900,423407,750179,325038,561737,304002,198672,907152,165551,448278,85453,74412,742060,779755,579344,5297,205038,663557,353556,500439,987579,96860,674154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 234511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 234511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001290s ]