SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53487 LIMIT 1 [ RunTime:0.003735s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53487 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001501,15887,244366,911144,29494,715974,830693,18020,630785,658635,860243,956329,601936,818669,39059,870039,197849,326716,702268,1010531,263692,52729,206082,657145,991005,938113,463894,574822,678122,789776,471224,342836,608712,236306,604272,671781,408917,874874,395122,689598,832561,462561,825297,415533,124629,55424,1045457,923358,313748,800149,593094,761266,156024,381483,485764,803242,67873,509291,630328,472346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]